package com.temp.interval;

import cn.hutool.core.date.DateField;

import java.util.Date;

public class IntervalMain {
    public static void main(String[] args) {
        IntervalBuilder monthSql = new IntervalBuilder().setDf(DateField.MONTH).setNumColumn(" t.quantity ")
                .setPoint(new Date()).setTimeColumn(" t.cur_entry_time_warehouse ").setIntervals(3, 4).action();
        for (String s : monthSql.getSqlList()) {
            System.out.println(s);
        }
        System.out.println("******************************************************************************************************************************************************************************");
        IntervalBuilder monthSql2 = new IntervalBuilder().setForward(true).setDf(DateField.MONTH).setNumColumn(" t.quantity ")
                .setPoint(new Date()).setTimeColumn(" t.cur_entry_time_warehouse ").setIntervals(3, 8).action();
        for (String s : monthSql2.getSqlList()) {
            System.out.println(s);
        }
    }
}
